It might be a database ...

Okay guys and gals,
MS communities has never let me down ...

I'm not certain which group to post this to, so direct me to the correct on
please. I am not cross-posting.

I have 200+ PDF files, they have matching HTML files, and they have matching
text files.

I just want a description, document number, and links to the three files
(times 200 ...) In table format, or any easily readable format, then included
on an HTML page for users to select the document and format of their choice.

Doc# | Description |PDF |HTML|TEXT
_______________________________
001 | Dead P.I.'s | X | X | X
_______________________________

You get the picture ...

What do I need to automate this process as much as possible?

Thanks so much,
Miles
--
Posted from
http://communities2.microsoft.com/communities/newsgroups/en- us/default.aspx

Re: It might be a database ...

"Miles Archer" wrote in message
news:77205A31-BF7A-4070-993D-7EC1A328AECA@microsoft.com...
: Okay guys and gals,
: MS communities has never let me down ...
:
: I'm not certain which group to post this to, so direct me to the correct
on
: please. I am not cross-posting.
:
: I have 200+ PDF files, they have matching HTML files, and they have
matching
: text files.
:
: I just want a description, document number, and links to the three files
: (times 200 ...) In table format, or any easily readable format, then
included
: on an HTML page for users to select the document and format of their
choice.
:
: Doc# | Description |PDF |HTML|TEXT
: _______________________________
: 001 | Dead P.I.'s | X | X | X
: _______________________________
:
: You get the picture ...
:
: What do I need to automate this process as much as possible?

Are you asking to automate the gathering of the file names from the drive
and then populate the page?

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

Re: It might be a database ...

Where do the files exist? Are they just all sitting in a directory on the
server? Or are they at various locations but cataloged in a database with
the names and paths? Where do you have the description data stored? In
this same database? What kind of database is it? What's the layout of the
relevant data in the database?

Ray at home


"Miles Archer" wrote in message
news:77205A31-BF7A-4070-993D-7EC1A328AECA@microsoft.com...
> Okay guys and gals,
> MS communities has never let me down ...
>
> I'm not certain which group to post this to, so direct me to the correct
> on
> please. I am not cross-posting.
>
> I have 200+ PDF files, they have matching HTML files, and they have
> matching
> text files.
>
> I just want a description, document number, and links to the three files
> (times 200 ...) In table format, or any easily readable format, then
> included
> on an HTML page for users to select the document and format of their
> choice.
>
> Doc# | Description |PDF |HTML|TEXT
> _______________________________
> 001 | Dead P.I.'s | X | X | X
> _______________________________
>
> You get the picture ...
>
> What do I need to automate this process as much as possible?
>
> Thanks so much,
> Miles
> --
> Posted from
> http://communities2.microsoft.com/communities/newsgroups/en- us/default.aspx

Re: It might be a database ...

"Roland Hall" wrote:

> Are you asking to automate the gathering of the file names from the drive
> and then populate the page?
>
> --
> Roland Hall

I'm willing to do whatever I need to do to keep from entering them all by
hand.

Right now they are just in a directory. I can load them into FP 2002, I can
load them up to a Unix server. I have ASP, PHP, MySQL, PostgreSQL, I can use
Access (but I am Access impared ... ). I suppose I could get ShareTeam, but I
think that would be hitting an ant with a sledge hammer. I can use IIS.

But, yes, I want to list the files, add a description and then populate a
page with links.

Re: It might be a database ...

They are just files on a server.
I haven't created a database yet because I wasn't convinced it was the best
route to take to accomplish my goal. (except maybe a flat file)

Even after I created a db, I still would have to make it display on an HTML
page, which I have no idea how to do.

I can go out and find dozens of free templates to create complex community
discussion boards (phpBB, etc.), but I couldn't locate any templates/scripts
that would list files, except ones that output something akin to a Unix
directory (i.e no comments).

Thanks.

"Ray Costanzo [MVP]" wrote:

> Where do the files exist? Are they just all sitting in a directory on the
> server? Or are they at various locations but cataloged in a database with
> the names and paths? Where do you have the description data stored? In
> this same database? What kind of database is it? What's the layout of the
> relevant data in the database?
>
> Ray at home

Re: It might be a database ...

"Miles Archer" wrote in message
news:77205A31-BF7A-4070-993D-7EC1A328AECA@microsoft.com...
> Okay guys and gals,
> MS communities has never let me down ...
>
> I'm not certain which group to post this to, so direct me to the correct
on
> please. I am not cross-posting.
>
> I have 200+ PDF files, they have matching HTML files, and they have
matching
> text files.
>
> I just want a description, document number, and links to the three files
> (times 200 ...) In table format, or any easily readable format, then
included
> on an HTML page for users to select the document and format of their
choice.
>
> Doc# | Description |PDF |HTML|TEXT
> _______________________________
> 001 | Dead P.I.'s | X | X | X
> _______________________________
>
> You get the picture ...
>
> What do I need to automate this process as much as possible?
>
> Thanks so much,
> Miles

Please give us more information.

Are the files all in the same folder?

Are the files in folder(s) under the web root folder? If so, waht is the
path?

Is there a naming convention to the files? If so, what is it?

Do the descriptions already exist?
Perhaps as the first line in the corresponding text files?
If not, can you create a text file that identifies each?

Apparently you want the list in order by "Doc#"; does that relate to file
name in any way?

Will the nunber of files change; if so, how many and how frequently?

You probably don't need a database...

Let's say:

1) you have the files in a folder call PDF under the page that the Web
page is.

2) that all files start with "Doc#" followed by 3 digits followed by
".htm", "pdf", or ".txt".

3) that you have a file ("Doc#.txt") that contains the descriptions of
all of the files.

4) that the layout of this file is "file prefix" followed by "=" followed
by "description";
for example, "Doc#001=Dead P.I.'s" or "001=Dead P.I.'s".

Do you want a solution for the above requirements?

Re: It might be a database ...

"Miles Archer" wrote in message
news:169E6471-BDA9-442C-AEEE-2071BB4DB533@microsoft.com...
: "Roland Hall" wrote:
:
: > Are you asking to automate the gathering of the file names from the
drive
: > and then populate the page?
: >
: > --
: > Roland Hall
:
: I'm willing to do whatever I need to do to keep from entering them all by
: hand.
:
: Right now they are just in a directory. I can load them into FP 2002, I
can
: load them up to a Unix server. I have ASP, PHP, MySQL, PostgreSQL, I can
use
: Access (but I am Access impared ... ). I suppose I could get ShareTeam,
but I
: think that would be hitting an ant with a sledge hammer. I can use IIS.
:
: But, yes, I want to list the files, add a description and then populate a
: page with links.

something like this?
http://kiddanger.com/lab/filelist.asp

It gathers all the .txt files in the same directory only, since you said
there are 3 of each (html, pdf, txt) but strips off the file extension. It
opens a .txt file with a list of the file descriptions, puts that into an
array, then filters this array based upon the prefix of the filename. It
then loops through each file in the array and writes the file prefix,
description, and three links for the file with the 3 extensions.

It won't matter how many files you have but the filename should be unique
enough so that they do not duplicate in the file descriptions, otherwise, I
would store the file name prefix in the list with the description so you
know which description to assign to which file without error.

No database is involved. It's not pretty but cosmetics usually come last.

HTH...

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

Re: It might be a database ...

"McKirahan" wrote in message
news:NPSdnUBJiJKGNXrcRVn-3A@comcast.com...
> "Miles Archer" wrote in message
> news:77205A31-BF7A-4070-993D-7EC1A328AECA@microsoft.com...
> > Okay guys and gals,
> > MS communities has never let me down ...
> >
> > I'm not certain which group to post this to, so direct me to the correct
> on
> > please. I am not cross-posting.
> >
> > I have 200+ PDF files, they have matching HTML files, and they have
> matching
> > text files.
> >
> > I just want a description, document number, and links to the three files
> > (times 200 ...) In table format, or any easily readable format, then
> included
> > on an HTML page for users to select the document and format of their
> choice.
> >
> > Doc# | Description |PDF |HTML|TEXT
> > _______________________________
> > 001 | Dead P.I.'s | X | X | X
> > _______________________________
> >
> > You get the picture ...
> >
> > What do I need to automate this process as much as possible?
> >
> > Thanks so much,
> > Miles

[snip]

Using a "Doc#.txt" file like:

Doc=Description
---------------
001=One
002=Two
003=Three
004=Four
005=Five
006=Six
007=Seven
008=Eight
009=Nine

The following "Doc#.vbs" script generates "Doc#.htm" which is an HTML table
that can be inserted into your Web page. Regenerate it then cut-and-paste
it each time the list of documents change.

Modify the Constanst "cFOL" to point to the subfolder that the files are in.

If the folder doesn't exist then the script exits.

If a file doesn't exist then it's table column will be blank.

Watch for word-wrap.

Option Explicit
'*
'* Declare Constants
'*
Const cVBS = "Doc#.vbs"
Const cTXT = "Doc#.txt"
Const cHTM = "Doc#.htm"
Const cFOL = "files\"
'*
'* Declare Variables
'*
Dim arrBGC(1)
arrBGC(0) = "#FFFFFF"
arrBGC(1) = "#EEEEEE"
Dim arrDOC
Dim intDOC
intDOC = 0
Dim strDOC
Dim arrEXT(2)
arrEXT(0) = ".pdf"
arrEXT(1) = ".htm"
arrEXT(2) = ".txt"
Dim intEXT
Dim strHTM
Dim strOTF
Dim arrSTR()
ReDim arrSTR(100)
Dim intSTR
intSTR = 0
Dim strSTR
Dim arrTXT
Dim intTXT
Dim strTXT
'*
'* Declare Objects
'*
Dim objFSO
Set objFSO = CreateObject("Scripting.FileSystemObject")
If Not objFSO.FolderExists(cFOL) Then WScript.Quit
Dim objOTF
'*
'* Read File
'*
Set objOTF = objFSO.OpenTextFile(cTXT,1)
strOTF = objOTF.ReadAll()
Set objOTF = Nothing
'*
'* Build Table
'*
Append "

Re: It might be a database ...

"McKirahan" wrote:

> "Miles Archer" wrote in message
> news:77205A31-BF7A-4070-993D-7EC1A328AECA@microsoft.com...
> > Okay guys and gals,
> > MS communities has never let me down ...
> >
> > I'm not certain which group to post this to, so direct me to the correct
> > on please. I am not cross-posting.
> >
> > I have 200+ PDF files, they have matching HTML files, and they have
> > matching text files.
> >
> > I just want a description, document number, and links to the three files
> > (times 200 ...) In table format, or any easily readable format, then
> > included
> > on an HTML page for users to select the document and format of their
> > choice.
> >
> > Doc# | Description |PDF |HTML|TEXT
> > _______________________________
> > 001 | Dead P.I.'s | X | X | X
> > _______________________________
> >
> > You get the picture ...
> >
> > What do I need to automate this process as much as possible?
> >
> > Thanks so much,
> > Miles
>
> Please give us more information.

Sorry. I wasn't certain what info you would need.

> Are the files all in the same folder?

They are under a folder named 'documents', then the files are in a folder
that identifies them "98-5643", "04-9876", etc. Each folder has a matching
PDF and text file within that folder. ("98-5634.PDF", and "98-5634.TXT", etc.
) The HTML pages are a little more complex. They are in the appropriate
folders, but each one has multiple pages. index.html is set up as a frames
page with navigation frames. Index.html has the document name as the
and the meta-tag description is the documents
"preview description". It would be difficult to put all the HTML pages under
the same folder because they all contain "index.html", "page_001.html", etc.

> Are the files in folder(s) under the web root folder? If so, waht is the
> path?

I can put them there, and I can alias the path on the server. On Unix it
would be var/www/document on Windows it would be C:\ or using Inetpub it
would be C:\Inetpub\wwwroot. I would prefer to use the Unix, but I am
flexible.

> Is there a naming convention to the files? If so, what is it?

It varies. Some are the 2 digit year followed with 4 numbers, some have an
internal naming convention using alpha numeric names.

> Do the descriptions already exist?
> Perhaps as the first line in the corresponding text files?
> If not, can you create a text file that identifies each?

It would not be a problem to create text files that contain the information.
Mostly a copy & paste operation.

> Apparently you want the list in order by "Doc#"; does that relate to file
> name in any way?

Yes, I believe you will see that when you read what I have already written.

> Will the nunber of files change; if so, how many and how frequently?

The files will be added to at about 20 a month.

> You probably don't need a database...

I didn't thik so, but I wasn't sure. (Hence the name of my post)

> Let's say:
>
> 1) you have the files in a folder call PDF under the page that the Web
> page is.
>
> 2) that all files start with "Doc#" followed by 3 digits followed by
> ".htm", "pdf", or ".txt".

The HTML pages break this convention. I could rename the index.html for
each one to the document number.html if I needed to.

> 3) that you have a file ("Doc#.txt") that contains the descriptions of
> all of the files.

The Doc#.txt would need to be diffferent since the actual text file of the
document already has that name taken. I could use "Doc#-2.txt" or
"Doc#info.txt", or some such convention.

> 4) that the layout of this file is "file prefix" followed by "=" followed
> by "description";
> for example, "Doc#001=Dead P.I.'s" or "001=Dead P.I.'s".

"001=Dead P.I.'s" would be the most correct.

> Do you want a solution for the above requirements?

Unless my folder situation has thrown a monkey wrench into it, yes please.

I thank you for your time.

Re: It might be a database ...

[snip]

I forgot that you posted your question in an ASP group.

You don't have to cut-and-paste the table when the list of documents change.

Just put my script in your ASP page and:
1) change "CreateObject()" to "Server.CreateObject()"
2) remove the "Write File" logic
3) insert <%=Concat()%> in your page where you want the table
4) remove the "MsgBox" and the "cVBS" and "cHTM" contsants.

Re: It might be a database ...

I will give this a try and see if it works for me.

I haven't worked much with VBS, but if I can manage machine code and
binary-encoded hexadecimal I should be able to slash away at this short code.
I'm always up for a challange ... :-)

Is there a repository of VBScripts, or do you have to wing this stuff?

I sincerely thank you for your time and will post back.

"McKirahan" wrote:

> "McKirahan" wrote in message
> news:NPSdnUBJiJKGNXrcRVn-3A@comcast.com...
> > "Miles Archer" wrote in message
> > news:77205A31-BF7A-4070-993D-7EC1A328AECA@microsoft.com...
> > > Okay guys and gals,
> > > MS communities has never let me down ...
> > >
> > > I'm not certain which group to post this to, so direct me to the correct
> > on
> > > please. I am not cross-posting.
> > >
> > > I have 200+ PDF files, they have matching HTML files, and they have
> > matching
> > > text files.
> > >
> > > I just want a description, document number, and links to the three files
> > > (times 200 ...) In table format, or any easily readable format, then
> > included
> > > on an HTML page for users to select the document and format of their
> > choice.
> > >
> > > Doc# | Description |PDF |HTML|TEXT
> > > _______________________________
> > > 001 | Dead P.I.'s | X | X | X
> > > _______________________________
> > >
> > > You get the picture ...
> > >
> > > What do I need to automate this process as much as possible?
> > >
> > > Thanks so much,
> > > Miles
>
> [snip]
>
> Using a "Doc#.txt" file like:
>
> Doc=Description
> ---------------
> 001=One
> 002=Two
> 003=Three
> 004=Four
> 005=Five
> 006=Six
> 007=Seven
> 008=Eight
> 009=Nine
>
> The following "Doc#.vbs" script generates "Doc#.htm" which is an HTML table
> that can be inserted into your Web page. Regenerate it then cut-and-paste
> it each time the list of documents change.
>
> Modify the Constanst "cFOL" to point to the subfolder that the files are in.
>
> If the folder doesn't exist then the script exits.
>
> If a file doesn't exist then it's table column will be blank.
>
> Watch for word-wrap.
>
> Option Explicit
> '*
> '* Declare Constants
> '*
> Const cVBS = "Doc#.vbs"
> Const cTXT = "Doc#.txt"
> Const cHTM = "Doc#.htm"
> Const cFOL = "files\"
> '*
> '* Declare Variables
> '*
> Dim arrBGC(1)
> arrBGC(0) = "#FFFFFF"
> arrBGC(1) = "#EEEEEE"
> Dim arrDOC
> Dim intDOC
> intDOC = 0
> Dim strDOC
> Dim arrEXT(2)
> arrEXT(0) = ".pdf"
> arrEXT(1) = ".htm"
> arrEXT(2) = ".txt"
> Dim intEXT
> Dim strHTM
> Dim strOTF
> Dim arrSTR()
> ReDim arrSTR(100)
> Dim intSTR
> intSTR = 0
> Dim strSTR
> Dim arrTXT
> Dim intTXT
> Dim strTXT
> '*
> '* Declare Objects
> '*
> Dim objFSO
> Set objFSO = CreateObject("Scripting.FileSystemObject")
> If Not objFSO.FolderExists(cFOL) Then WScript.Quit
> Dim objOTF
> '*
> '* Read File
> '*
> Set objOTF = objFSO.OpenTextFile(cTXT,1)
> strOTF = objOTF.ReadAll()
> Set objOTF = Nothing
> '*
> '* Build Table
> '*
> Append "

Re: It might be a database ...

"Miles Archer" wrote in message
news:2E45CACC-6D3B-4EBF-9F09-0AD30D9C0DD4@microsoft.com...

[snip]

A few questions...

> Sorry. I wasn't certain what info you would need.
>
> > Are the files all in the same folder?
>
> They are under a folder named 'documents', then the files are in a folder
> that identifies them "98-5643", "04-9876", etc. Each folder has a
matching
> PDF and text file within that folder. ("98-5634.PDF", and "98-5634.TXT",
etc.
> ) The HTML pages are a little more complex. They are in the appropriate
> folders, but each one has multiple pages. index.html is set up as a frames
> page with navigation frames. Index.html has the document name as the
> and the meta-tag description is the documents
> "preview description". It would be difficult to put all the HTML pages
under
> the same folder because they all contain "index.html", "page_001.html",
etc.
>
> > Are the files in folder(s) under the web root folder? If so, waht is
the
> > path?
>
> I can put them there, and I can alias the path on the server. On Unix it
> would be var/www/document on Windows it would be C:\ or using Inetpub it
> would be C:\Inetpub\wwwroot. I would prefer to use the Unix, but I am
> flexible.
>
> > Is there a naming convention to the files? If so, what is it?
>
> It varies. Some are the 2 digit year followed with 4 numbers, some have an
> internal naming convention using alpha numeric names.
>

Given the above, do the following exist?

c:\inetpub\wwwroot\documents\98-5634.PDF
c:\inetpub\wwwroot\documents\98-5634.TXT
c:\inetpub\wwwroot\documents\98-5634\index.html

Is the Description you want the



<%=Concat%>

Re: It might be a database ...

"Miles Archer" wrote in message
news:7C20442D-4901-4F08-BB08-655599EF50EF@microsoft.com...
:I will take a loook at it directly. I've been up all night, but I still
have
: a bit of steam.

Miles... what is the URL to your site?

Re: It might be a database ...

"McKirahan" wrote:

> "Miles Archer" wrote in message
> > "McKirahan" wrote:
> >
> > > "Miles Archer" wrote in message
> > >
> > >
> > > [snip]
> >
> > >
> > > Given the above, do the following exist?
> > >
> > > c:\inetpub\wwwroot\documents\98-5634.PDF
> > > c:\inetpub\wwwroot\documents\98-5634.TXT
> > > c:\inetpub\wwwroot\documents\98-5634\index.html
> >
> > Yes. That is the way they exist.
> >
> >
> > > Is the Description you want the
>
>
>
> <%=Concat%>
>
>

It's not working for me.
c:\wwwroot\inetpub\ isn't my root. it is c:\inetpub\wwwroot\, but I'm not
certain that's the problem - It's just a comment, right?

Browsing to c:\inetpub\wwwroot\ redirects me to http://localhost so perhaps
that's the problem.

I closed the line:
Append "

Re: It might be a database ...

"Miles Archer" wrote in message
news:C9E26214-8A19-4396-A374-347F7DB80496@microsoft.com...
> We have lift-off! It is a thing of beauty. See below.

[snip]

> > Please verify that the page is in the folder above the "documents"
folder
> > and that the following paths and relationships are still true:
> >
> > c:\inetpub\wwwroot\documents\98-5634.PDF
> > c:\inetpub\wwwroot\documents\98-5634.TXT
> > c:\inetpub\wwwroot\documents\98-5634\index.html
>
> Yes, that is where they were, but I had to move the PDF and Text documents
> under the 98-5634 folder to make the script work.
> Thus:
> c:\inetpub\wwwroot\documents\98-5634\98-5634.PDF
> c:\inetpub\wwwroot\documents\98-5634\98-5634.TXT
> c:\inetpub\wwwroot\documents\98-5634\index.html

I used "cFOL" too many times.

If you want the files where you had them, try the amended script below.

> I found two instances of CreateObject. Using Server.CreateObject seems to
> make no difference, even when the script functions properly.

Since your ASP page runs on the server you should use
"Server.CreateObject()".

I added this line as an after thought
<%@ Language = "VBScript" %>
which out this line where it shouldn't be
<% Option Explicit

> So I guess FrontPage is a WYDSIWYG editor too ... (What you Don't see is
> what you get)

I hate FP and never use it!

> I did a little reformatting and amended the comments. I changed:
> Const cFOL = "documents\" into
> Const cFOL = "documents/"
> and
> strHTM = strPRE & "\index.html" into
> strHTM = strPRE & "/index.html" to make it more browser friendly.

You should really use "\" (not "/") in this case.

When refering to a URL use you "/" as in http://localhost/page.asp

When referenceing a file in the filesystem use "\" as in
"c:\inetpub\wwwroot\page.asp" -- as I'm doing.



> When I figure out how to call it properly on Unix with Sun ONE Active
Server
> Pages I will post a link.
>
> It's just missing one thing. A credit. Please tell me what you would like
> displayed on the page.

How about just or


> Thank you so much.

You're very welcome -- I like challenges.

[snip]

<%@ Language="VBScript" %>
<% Option Explicit
'****
'* This ASP (Active Server Page) does the following:
'* 1) Determines if folder "cFOL" exists.
'* 2) Extracts the names of all PDF files in this folder.
'* 3) Sort the PDF file names.
'* 4) For each PDF file name build a row in an HTML table.
'* 5) Displays this table in a Web page.
'*
'* The following is expected under "c:\inetpub\wwwroot\"
'* 1) \documents\#.pdf
'* 2) \documents\#.txt
'* 3) \documents\#\index.html (meta tag contains description)
'*
'* Each row will contain a hyperlinked "X" if the file exists.
'****
'*
'* Declare Constants
'*
Const cASP = "Doc.asp"
Const cFOL = "documents/"
Const cRST = "Doc"
'*
Const adChar = 129
Const adLockBatchOptimistic = 4
Const adOpenStatic = 3
Const adUseClient = 3
'*
'* Declare Variables
'*
Dim arrBGC(1)
arrBGC(0) = "#FFFFFF"
arrBGC(1) = "#EEEEEE"
Dim arrDOC
Dim intDOC
intDOC = 0
Dim strDOC
Dim intDSC
Dim strDSC
Dim strFIL
Dim strHTM
Dim strLNK
Dim strOTF
Dim strPRE
Dim intRST
Dim strRST
Dim arrSTR()
ReDim arrSTR(100)
Dim intSTR
intSTR = 0
Dim strSTR
Dim strTAG
strTAG = " strTAG = Replace(strTAG,"`",Chr(34))
Dim strTXT
Dim strWWW
strWWW = Request.ServerVariables("PATH_TRANSLATED")
strWWW = Left(strWWW,InStrRev(strWWW,"\"))
'*
'* Declare Objects
'*
Dim objFSO
Set objFSO = Server.CreateObject("Scripting.FileSystemObject")
If Not objFSO.FolderExists(strWWW & cFOL) Then
Response.Write "
Path does not exist!
"
Response.End
End If
Dim objGFO
Dim objOTF
Dim objRST
Set objRST = Server.CreateObject("ADODB.RecordSet")
objRST.CursorLocation = adUseClient
objRST.LockType = adLockBatchOptimistic
objRST.CursorType = adOpenStatic
objRST.ActiveConnection = Nothing
objRST.Fields.Append cRST, adChar, 255
objRST.Open
'*
'* Read File
'*
Set objGFO = objFSO.GetFolder(strWWW)
For Each strFIL in objGFO.Files
If LCase(Right(strFIL.Name,4)) = ".pdf" Then
objRST.AddNew
objRST.Fields(cRST) = strFIL.Name
objRST.Update
End If
Next
Set objGFO = Nothing
'*
'* Sort RecordSet
'*
objRST.Sort = cRST
objRST.MoveFirst
'*
'* Build Table Heading
'*
Append "

Re: It might be a database ...

"McKirahan" wrote:

> "Miles Archer" wrote in message
> > We have lift-off! It is a thing of beauty. See below.
>
> [snip]
>
> > > Please verify that the page is in the folder above the "documents"
> > > folder
> > > and that the following paths and relationships are still true:
> > >
> > > c:\inetpub\wwwroot\documents\98-5634.PDF
> > > c:\inetpub\wwwroot\documents\98-5634.TXT
> > > c:\inetpub\wwwroot\documents\98-5634\index.html
> >
> > Yes, that is where they were, but I had to move the PDF and Text documents
> > under the 98-5634 folder to make the script work.
> > Thus:
> > c:\inetpub\wwwroot\documents\98-5634\98-5634.PDF
> > c:\inetpub\wwwroot\documents\98-5634\98-5634.TXT
> > c:\inetpub\wwwroot\documents\98-5634\index.html
>
> I used "cFOL" too many times.
>
> If you want the files where you had them, try the amended script below.

It makes sense where it is now. But I'll try your amended script below anyway.

> > I found two instances of CreateObject. Using Server.CreateObject seems to
> > make no difference, even when the script functions properly.
>
> Since your ASP page runs on the server you should use
> "Server.CreateObject()".

I Server.CreateObject in use.

> I added this line as an after thought
> <%@ Language = "VBScript" %>
> which out this line where it shouldn't be
> <% Option Explicit

Yes, I noticed that there seemed to be a correlation between where <% Option
Explicit starts from the left hand side and how the code below it is
processed.

> > So I guess FrontPage is a WYDSIWYG editor too ... (What you Don't see is
> > what you get)
>
> I hate FP and never use it!

What do you use to manage and apply large site-wide changes? I have been
through several web editors, but that is what they do - edit; They tend to be
weak on managing.

Actually, I think the FP error was more a WinXP Pro problem than FP. When I
pasted your original post into Notepad, I used the default ANSI encoding to
save it and droped it into FP and changed the extension. There is also
Unicode, Unicode big endian(?), and UTF-8 encoding available in Notepad. I'm
not sure which to use, because I fired up NoteTAB lite and had no problems.
(I never had problems with Notepad on my trusty Win98 SE machine, so I don't
know WHAT is going on...)

> > I did a little reformatting and amended the comments. I changed:
> > Const cFOL = "documents\" into
> > Const cFOL = "documents/"
> > and
> > strHTM = strPRE & "\index.html" into
> > strHTM = strPRE & "/index.html" to make it more browser friendly.
>
> You should really use "\" (not "/") in this case.
>
> When refering to a URL use you "/" as in http://localhost/page.asp
>
> When referenceing a file in the filesystem use "\" as in
> "c:\inetpub\wwwroot\page.asp" -- as I'm doing.

I see your point, and it even occured to me as I was making the changes. But
the script resides on a server. What else would you use to generate a table
except a server and what else would you use to view a table on a server
except a browser? (I really don't know)

Without changing the slashes, the hyperlinks in the generated table were
http:\\localhost/98-5634/98-5634.PDF, which many browsers won't accept.


> > When I figure out how to call it properly on Unix with Sun ONE Active
> > Server Pages I will post a link.

I think I will end up creating the tables locally and pasting them into a
new page on the server. The script is "running" without errors on Linux w/Sun
ASP, but nothing dispalys except the HTML. The Sun ASP server is 2001
vintage, so I suspect some commands are different than expected - It's
probably killing the script in response to a command in the script.

> > It's just missing one thing. A credit. Please tell me what you would like
> > displayed on the page.
>
> How about just or
>

You got it!

> > Thank you so much.
>
> You're very welcome -- I like challenges.

I enjoy the challange too. I always get worried that the person on the
"other end" will give up before a solution is arrived at (whether I am giving
or getting advice). I would have kept at it another week at least. (I'm
going to try and add Word documents to it now that you have given me such an
excellent primer/starting point.)

Fair winds and following seas
(Best of luck, in Navy-eze)

Re: It might be a database ...

"McKirahan" wrote in message news:P_SdnYQZK9IYnXHcRVn-sA@comcast.com...
: "Miles Archer" wrote in message
: news:C9E26214-8A19-4396-A374-347F7DB80496@microsoft.com...
: > We have lift-off! It is a thing of beauty. See below.
:
: > I found two instances of CreateObject. Using Server.CreateObject seems
to
: > make no difference, even when the script functions properly.
:
: Since your ASP page runs on the server you should use
: "Server.CreateObject()".

I thought using Server.CreateObject in lieu of CreateObject was due to MTS
being used. If not needed, Server.CreateObject would create unnecessary
overhead.

4Guys says:
http://www.4guysfromrolla.com/webtech/043099-1.shtml

But then Bernard Cheah (IIS MVP) says:
http://www.iis-resources.com/modules/newbb/viewtopic.php?top ic_id=2410&forum=10

Eric Lippert says:
http://blogs.msdn.com/ericlippert/archive/2004/06/01/145686. aspx


--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

Re: It might be a database ...

"Miles Archer" wrote in message
news:F6FE6CFA-F79D-4D19-8F44-E0C0A49B04C9@microsoft.com...

[snip]

> What do you use to manage and apply large site-wide changes? I have been
> through several web editors, but that is what they do - edit; They tend to
be
> weak on managing.

Dreamweaver is popular.

[snip]

> > > I did a little reformatting and amended the comments. I changed:
> > > Const cFOL = "documents\" into
> > > Const cFOL = "documents/"
> > > and
> > > strHTM = strPRE & "\index.html" into
> > > strHTM = strPRE & "/index.html" to make it more browser friendly.
> >
> > You should really use "\" (not "/") in this case.
> >
> > When refering to a URL use you "/" as in http://localhost/page.asp
> >
> > When referenceing a file in the filesystem use "\" as in
> > "c:\inetpub\wwwroot\page.asp" -- as I'm doing.
>
> I see your point, and it even occured to me as I was making the changes.
But
> the script resides on a server. What else would you use to generate a
table
> except a server and what else would you use to view a table on a server
> except a browser? (I really don't know)

ASP runs on the server and FSO accesses the filesystem thus the use of "/"
amd "\" (respectively) is appropriate.

> Without changing the slashes, the hyperlinks in the generated table were
> http:\\localhost/98-5634/98-5634.PDF, which many browsers won't accept.
>
>
> > > When I figure out how to call it properly on Unix with Sun ONE Active
> > > Server Pages I will post a link.
>
> I think I will end up creating the tables locally and pasting them into a
> new page on the server. The script is "running" without errors on Linux
w/Sun
> ASP, but nothing dispalys except the HTML. The Sun ASP server is 2001
> vintage, so I suspect some commands are different than expected - It's
> probably killing the script in response to a command in the script.

You could "include" the resulting file in your ASP page via:

rather than cut-and-paste.


> > > It's just missing one thing. A credit. Please tell me what you would
like
> > > displayed on the page.
> >
> > How about just or
> >
>
> You got it!
>
> > > Thank you so much.
> >
> > You're very welcome -- I like challenges.
>
> I enjoy the challange too. I always get worried that the person on the
> "other end" will give up before a solution is arrived at (whether I am
giving
> or getting advice). I would have kept at it another week at least. (I'm
> going to try and add Word documents to it now that you have given me such
an
> excellent primer/starting point.)
>
> Fair winds and following seas
> (Best of luck, in Navy-eze)